TemporaryPriceChange

Entity Definition

Logical Name : TemporaryPriceChange
Physical Name : TR_CHN_TMP_PRC

A type of ITEM - MAINTENANCE EVENT that is a temporary change to the current retail price for a specific time period, usually for the duration of a promotion. The WORKSTATION will record the net sales of these ITEMs.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EventID (FK)(PK) A unique, automatically assigned identifier for the Event ID_EV Identity integer
SaleUnitAmount The amount (either monetary or percent) to be used to change or replace the current selling price for a sale unit of the item. RP_UN_TMP_PRC_CHN MoneyShortRetail decimal(7,2)
SaleUnitAmountTypeCode A code to define how the temporary-price-change-sale-unit-amount is to be interpreted. Valid values include: PCT percent of current retail price to be added to or subtracted from the current retail to arrive at a selling price; AMT, flat monetary amount to be added to or subtracted from the current retail to arrive at a selling price; and AMTREPL, a retail sale unit price amount that is to replace the current selling price. TY_UN_TMP_PRC_CHN Code2 char(2)

Relationships

Parent Entity Verb Phrase Child Entity
TemporaryPriceChange changes price for TemporaryPriceChangeItem
ItemPriceMaintenance can be a TemporaryPriceChange

Logical Views containing TemporaryPriceChange

Logical View
Logical 01300 - Item Price Maintenance View
Logical 06700 - Event Scheduler View